import pandas as pd

list1 = [['张三',80,'男'],['李四',70,'女'],['王五',40,'女']]
df1 = pd.DataFrame(list1,columns = ['姓名','分数','性别'])
print(df1)

list2 = [[80,'优秀'],[70,'良好'],[60,'合格'],[50,'差'],[40,'差']]
df2 = pd.DataFrame(list2,columns=['成绩','评价'])
print(df2)

df1['评价'] = df1.apply(lambda x:df2[df2['成绩']==x['分数']]['评价'].values[0] ,axis = 1)
print(df1)